Bentley Raceway and Cable Management CONNECT Edition Help

SESSION AUTOCOMMIT [OFF|ON]

Used to activate a mode in which Bentley Raceway and Cable Management does not automatically commit SQL statements to the database software for processing.

SQL statements are generated by Bentley Raceway and Cable Management each time you use certain database tools and key-ins. For example, Bentley Raceway and Cable Management generates a SQL INSERT statement when you use the Attach Active Entity tool. You can also submit SQL statements in the SQL Window.

By default, Bentley Raceway and Cable Management immediately commits SQL statements to the database software. In the alternate mode, Bentley Raceway and Cable Management commits statements only when your input necessitates the addition of a row to a database table. The process of adding rows requires the database software to lock tables, and commitment is required to release those locks. The alternate mode can be useful when it is desirable to be able to undo uncommitted SQL statements.

In the alternate mode, you can explicitly request Bentley Raceway and Cable Management to commit statements by submitting COMMIT in the SQL Window. To undo all statements to the last commit point, submit ROLLBACK in the SQL Window.